home
***
CD-ROM
|
disk
|
FTP
|
other
***
search
/
The World of Computer Software
/
The World of Computer Software.iso
/
xtros2.zip
/
XTROS2.DOC
< prev
Wrap
Text File
|
1992-12-30
|
19KB
|
572 lines
Filename: XTROS2.DOC
Product: Xtrieve PLUS v4.11 for OS/2
Date: December 1992
This Readme document accompanies the OS/2 environment patches for Xtrieve
PLUS v4.11 programs and utilities.
================================================================================
Disclaimer
==========
Novell, Inc. makes no representations or warranties with respect to any
NetWare software, and specifically disclaims any express or implied
warranties of merchantability, title, or fitness for a particular purpose.
Distribution of any NetWare software is forbidden without the express written
consent of Novell, Inc. Further, Novell reserves the right to discontinue
distribution of any NetWare software.
Novell is not responsible for lost profits or revenue, loss of use of the
software, loss of data, costs of re-creating lost data, the cost of any
substitute equipment or program, or claims by any party other than you.
Novell strongly recommends a backup be made before any software is installed.
Technical support for this software may be provided at the discretion of
Novell.
PATCH.EXE is a proprietary product of PocketSoft. PATCH.EXE and Patch Build
generated files are distributed by Novell, Inc. under license from
PocketSoft.
================================================================================
Contents
========
Installation Procedure
Patch File Information
Original File Information
Patch Set Descriptions
Documentation Updates
================================================================================
Installation Procedure
======================
The PATCHXTR.CMD and PATCH.EXE files mentioned in this procedure require
OS/2 v1.1 or later.
The XTROS2.ZIP file contains the following:
- This Readme document
- PATCH.EXE, a utility Novell provides for installing product patches
- PATCHXTR.CMD, a batch file to facility patch installation
- Patch files (XTRIEVE.411 and XQLCALLS.211)
- Replacement files (files with the same names as the files they will
replace)
To install the Xtrieve PLUS patch set, complete the following steps:
1. Create a directory on your system, and copy the XTROS2.ZIP file to
that directory.
2. Use the utility PKUNZIP.EXE to unzip the zipped files.
3. Install the patch files (XTRIEVE.411 and XQLCALLS.211) as follows:
a. Refer to the list of patch files in the section "Original File
Information," find the original files on your system, and ensure that
your original files match those listed.
b. Use the DOS COPY command to copy the original files into the
directory that contains the unzipped patch files from XTROS2.ZIP.
c. Run PATCHXTR, which verifies that you are patching the original
released version of the software, applies the patch, and gives the
original files an .ORG extension.
d. Use the DOS COPY command to copy the patched files back to the
original file's directory.
4. Install the replacement files as follows:
a. Find the directory that contains the original files to be
replaced.
b. Before copying the replacement files, back up the original files
to a diskette or to another directory.
c. Use the COPY command to replace the original files with the
new files.
5. After applying the patches, you can remove the directory you created to
store the XTROS2.ZIP file. You may also want to verify the version
numbers when you load each program. The version numbers should match
those listed in the next section, "Patch File Information."
================================================================================
Patch File Information
======================
Patch Set Filename: XTROS2.ZIP
Date: 12-30-92
Files Included: XTROS2 DOC This document
PATCH EXE 76981 1-30-92 5:00a
PATCHXTR CMD 3928 12-17-92 3:55p
(Patch file) XTROS2 411 v4.11b 64874 12-17-92 11:06a
XQLCALLS 211 538 12-17-92 3:27p
(Replacement files) MAKE_XTA EXE v4.11b 74858 12-09-92 10:54a
XCFP EXE v4.11b 57548 12-09-92 11:19a
XMENU EXE v4.11b 133592 12-09-92 11:14a
XTRIEVE MSG 39018 12-08-92 5:06p
XTRIEVE MEN v4.11b 13347 12-08-92 5:06p
XHFP EXE v4.11b 26192 12-09-92 11:17a
================================================================================
Original File Information
=========================
To ensure you are patching the original file, compare the file to be patched
with that in the following list. This list shows the byte size and the date
and time stamps for the original release.
Patch these files:
XTRIEVE EXE v4.11 464362 8-13-92 11:21a
XQLCALLS ORG v2.11 399291 10-18-90 12:28p
Replace these files:
MAKE_XTA EXE v4.11 71738 6-25-92 7:45p
XCFP EXE v4.11 56994 6-25-92 8:07p
XMENU EXE v4.11 133592 9-16-92 12:57p
XTRIEVE MSG 39017 8-11-92 3:59p
XTRIEVE MEN v4.11 13347 8-11-92 3:59p
XHFP EXE v4.11 26192 6-25-92 8:06p
================================================================================
Patch Set Descriptions
======================
This section describes each patch in the patch set. The patch descriptions
for the Xtrieve engine appear first, followed by those for the utilities.
For each patch, the description includes one or more search strings. These
search strings indicate areas in which you may encounter the problem that the
patch addresses. The search strings may help you quickly determine whether
the patch you need for a specific problem is included in this patch set.
NOTE: In some cases, the text describes a problem or reported bug that the
update does NOT fix. In those cases, use the workaround provided.
* * * * * * * * *
Product/Platform: OS/2 - XTRIEVE.EXE, v4.11
Search String: DISPLAY ERRORS
Problem:
In the Report Layout screen, when you insert a field between two fields that
take up a relatively large portion of the screen, Xtrieve PLUS redraws the
screen incorrectly. This patch does not contain a fix; Xtrieve PLUS
accurately stores the new data.
* * * * * * * * *
Product/Platform: OS/2 - XTRIEVE.EXE, v4.11
Search Strings: F8, HANG, MODIFYING, REPORT LAYOUT
Problem Fixed by This Patch:
When you repeatedly use the key sequence Shift+F8, F8, and Esc when modifying
or viewing groups or fields in a report layout, Xtrieve PLUS terminates.
This patch ensures that Xtrieve PLUS properly closes and reopens the report
layout windows, thus preventing Xtrieve PLUS from terminating.
* * * * * * * * *
Product/Platform: OS/2 - XTRIEVE.EXE, v4.11
Search Strings: GROUP FIELD, GROUP SUMMARY, REPORT FIELD, REPORT SUMMARY
Problem Fixed by This Patch:
If you use a report field in a report field summary or a group field in a
group field summary, Xtrieve PLUS does not allow you to remove or modify the
field. This patch ensures that Xtrieve PLUS allows you to remove or modify
such fields.
* * * * * * * * *
Product/Platform: OS/2 - XTRIEVE.EXE, v4.11
Search Strings: FORM/ADD EDIT SCREEN, INVALID RECORD
Problem Fixed by This Patch:
If you attempt to add an invalid record using the Form/Add edit screen,
Xtrieve PLUS exits the Form/Add edit screen and returns to the Form menu.
This patch ensures that if an error occurs when you attempt to add a record,
Xtrieve PLUS remains at the edit screen.
* * * * * * * * *
Product/Platform: OS/2 - XTRIEVE.EXE, v4.11
Search String: REPORT LAYOUT
Problem Fixed by This Patch:
When XQL and Btrieve are loaded by Xtrieve PLUS, a report layout may become
corrupt in memory after you print the report. This patch ensures that
Xtrieve PLUS correctly maintains report layouts.
* * * * * * * * *
Product/Platform: OS/2 - XTRIEVE.EXE, v4.11
Search String: REMOVE GROUP
Problem Fixed by This Patch:
If you remove a group from a report and then attempt to remove another
group, Xtrieve PLUS displays a repetitive list of groups from which to
choose. In addition, if you choose one of the listed groups, Xtrieve PLUS
causes the workstation to freeze. This patch ensures that Xtrieve PLUS
correctly displays lists of groups.
* * * * * * * * *
Product/Platform: OS/2 - XTRIEVE.EXE, v4.11
Search Strings: BLANKS, IMPORT DATA, SDF
Problem Fixed by This Patch:
Xtrieve PLUS incorrectly imports data in Standard Data Format (SDF) if
blanks separate the data elements, as in the following example:
"Firstname", "Middlename", "Lastname"
This patch ensures that Xtrieve PLUS correctly imports SDF data.
* * * * * * * * *
Product/Platform: OS/2 - XTRIEVE.EXE, v4.11
Search Strings: LVAR, NOTE, TRANSLATE, VARIABLE-LENGTH FIELDS
Problem Fixed by This Patch:
Xtrieve PLUS does not accurately perform view-to-view translations on
variable-length fields that are not of the same type. For example, you
cannot accurately translate a note field into an lvar field. This patch
ensures that Xtrieve PLUS correctly performs such translations.
* * * * * * * * *
Product/Platform: OS/2 - XTRIEVE.EXE, v4.11
Search Strings: CREATE FILE, PAGE, PREALLOCATION
Problem Fixed by This Patch:
When you are creating files, Xtrieve PLUS allows you to preallocate no more
than 32,767 pages. This patch ensures that Xtrieve PLUS allows you to
preallocate up to 65,535 pages.
* * * * * * * *
Product/Platform: OS/2 - XTRIEVE.EXE, v4.11
Search Strings: BTRIEVE, NEW COMMAND LINE OPTIONS, UNLOAD, XQL
Problem Fixed by This Patch:
Xtrieve PLUS does not unload Btrieve or XQL from memory if you loaded Btrieve
or XQL before you entered Xtrieve PLUS. If you do not have the utilities
BUTIL or NSUTIL, you cannot unload XQL or Btrieve from memory. This patch
makes available two new command line options you can specify when you load
Xtrieve PLUS:
/ua Unloads both XQL and Btrieve when you exit Xtrieve PLUS
/ux Unloads only XQL when you exit Xtrieve PLUS
* * * * * * * * *
Product/Platform: OS/2 - XTRIEVE.EXE, v4.11
Search Strings: CONDITIONAL, FIELD LIST, SCALAR FUNCTIONS,
USER-DEFINED FIELDS
Problem:
Xtrieve PLUS may not display all available fields in a field list when you
are defining a user-defined field that includes nested conditions or nested
scalar functions, as in the following example expression:
Result = SUBSTRING( SUBSTRING( SUBSTRING( Field3,5,20),2,Field2),5,Field1)
Workaround:
For each level of nesting, create a temporary, user-defined field, as in the
following example:
TempField1 = SUBSTRING( Field3,5,20)
TempField2 = SUBSTRING( TempField1,2,Field2)
TempField3 = SUBSTRING( TempField2,5,Field1)
Since Xtrieve PLUS embeds the temporary field definitions in the substring
field that references it, you can delete the interim temporary fields,
resulting in a single, user-defined field, as in the following example:
Result = TempField3
* * * * * * * * *
Product/Platform: OS/2 - XTRIEVE.EXE, v4.11
Search Strings: DECIMAL POINTS, INTEGER FIELDS, MASKS
Problem:
If you place a mask that contains decimal points (such as ZZZ,ZZ9.99) on an
integer field, you may get unexpected results in report summary fields. For
example, if the field's data is 38,470.00, the masked result is 384.70.
Workaround:
Masks on integer fields should not contain decimal points. Use a more
appropriate data type, such as decimal, float, money, or numeric.
* * * * * * * * *
Product/Platform: OS/2 - XQLCALLS.DLL
Search Strings:
Problem Fixed by This Patch:
* * * * * * * * *
Product/Platform: OS/2 - XTRIEVE.PDB
Search Strings: PRINTER, TABLOID SETTING
Problem:
The Tabloid setting of the XTRIEVE.PDB file specifies the Epson LQ-1500/2.0
printer instead of the IBM PC graphics printer.
Workaround:
Change the Tabloid setting as follows.
1. At a DOS workstation, enter SLATE XTRIEVE.PDB.
2. In the SLATE utility, follow these steps to set the Tabloid setting:
a. Select the Add/Edit Devices (Ptr Connections) option from the main
menu.
b. Select the 3001 Tabloid option from the Devices menu.
c. Use the Tab key to move to the Ptr Mfg field and press F9 to display
a list of printer manufacturers.
d. Select IBM.
e. Use the Tab key to move to the Ptr Type field and press F9 to display
a list of printer types.
f. Select PC Graphics Printer.
3. To exit SLATE, press F10 three times.
* * * * * * * * *
Product/Platform: OS/2 - MAKE_XTA.EXE, v4.11
Search Strings: 3, HANG, OPEN VIEWS
Problem Fixed by This Patch:
The MAKE_XTA utility hangs or returns Status Code 3 (File Not Open) when you
attempt to open certain views. This patch ensures that MAKE_XTA can open
such views.
* * * * * * * * *
Product/Platform: OS/2 - MAKE_XTA.EXE, v4.11
Search Strings: FIELD NAMES, LOWERCASE, UPPERCASE
Problem Fixed by This Patch:
The MAKE_XTA utility converts all letters in user-defined field names to
uppercase. This patch ensures that MAKE_XTA preserves lowercase letters in
field names.
* * * * * * * * *
Product/Platform: OS/2 - MAKE_XTA.EXE, v4.11
Search Strings: EQJOIN, EQUAL, JOIN, KEYWORD, NULL, NULLJOIN
Problem Fixed by This Patch:
The MAKE_XTA utility inserts incorrect keywords in .XTA files that contain
file joins. For example, MAKE_XTA uses the keyword EQUAL when it should use
the keyword EQJOIN. This patch ensures that MAKE_XTA inserts the correct
keywords.
* * * * * * * * *
Product/Platform: OS/2 - MAKE_XTA.EXE, v4.11
Search Strings: ADD KEYWORD, REPORT LAYOUT, SUM
Problem Fixed by This Patch:
If a report layout contains the calculation type SUM, the MAKE_XTA
utility inserts an extra .ADD. keyword in the XTA file. This patch ensures
that MAKE_XTA inserts the correct number of .ADD. keywords.
* * * * * * * * *
Product/Platform: OS/2 - MAKE_XTA.EXE, v4.11
Search Strings: BIT FIELDS, CONSECUTIVE FIELDS
Problem Fixed by This Patch:
If a dictionary contains two or more adjacent fields of type bit, the
MAKE_XTA utility inserts only the first bit field in the .XTA file. This
patch ensures that MAKE_XTA inserts all bit fields.
* * * * * * * * *
Product/Platform: OS/2 - MAKE_XTA.EXE, v4.11
Search Strings: AUTOINC, INDEX ATTRIBUTES
Problem Fixed by This Patch:
The MAKE_XTA utility incorrectly extracts the index attributes of fields of
type autoinc. This patch ensures that MAKE_XTA retains index attributes as
defined in the original file.
* * * * * * * * *
Product/Platform: OS/2 - MAKE_XTA.EXE, v4.11
Search Strings: EXTRACT FILES, SUPPLEMENTAL INDEX
Problem Fixed by This Patch:
The MAKE_XTA utility fails when attempting to extract files that contain
supplemental indexes. This patch ensures that MAKE_XTA correctly extracts
supplemental indexes.
* * * * * * * * *
Product/Platform: OS/2 - MAKE_XTA.EXE, v4.11
Search String: DESCRIPTIVE FILENAME
Problem Fixed by This Patch:
If a descriptive filename is shorter than the actual filename, the MAKE_XTA
utility pads the rest of the descriptive filename with characters from the
actual filename. For example, given a descriptive filename of FILE and an
actual filename of TESTING, MAKE_XTA converts the descriptive filename to
FILEING. This patch ensures that MAKE_XTA inserts the correct descriptive
filename into the generated .XTA file.
* * * * * * * * *
Product/Platform: OS/2 - MAKE_XTA.EXE, v4.11
Search Strings: EXTRACT VIEWS, USER-DEFINED FIELDS
Problem Fixed by This Patch:
The MAKE_XTA utility incorrectly extracts files containing relatively large
user-defined fields. This patch ensures that MAKE_XTA correctly extracts
such files.
* * * * * * * * *
Product/Platform: OS/2 - MAKE_XTA.EXE, v4.11
Search Strings: CONDITIONAL USER-DEFINED FIELDS, MASKS
Problem:
If you define a conditional user-defined field in Xtrieve PLUS and you define
a mask for the field, MAKE_XTA does not maintain the mask when it creates the
.XTA file.
Workaround:
Edit the .XTA file to restore the mask definitions for each conditional
user-defined field you want masked.
* * * * * * * * *
Product/Platform: OS/2 - XCFP.EXE, v4.11
Search Strings: COMMANDS WITH NUMERALS, PAGE SIZE
Problem Fixed by This Patch:
The Xtrieve PLUS Command File Processor (XCFP) utility does not recognize the
command that specifies page size since the command begins with a numeral.
This patch ensures that XCFP recognizes commands that begin with numerals.
================================================================================
Documentation Updates
=====================
NOTE: The documentation updates that follow are in addition to any
documentation updates noted in the Readme file of the original
product.
Note the following change to the "Xtrieve PLUS User's Manual:"
- Page A-49: Add the following status codes.
349 The Specified Data Value Is Too Large for the Field Definition
The data value you specified is larger than the maximum length
defined for the field.
350 Security Has Not Been Enabled on This Dictionary
You attempted an operation that can be done only when security is
enabled. Database security is not enabled at this time. To perform
the operation successfully, enable security on that database.
351 A Transaction Has Not Yet Been Started
You attempted to perform a COMMIT or ROLLBACK operation without being
inside a transaction. You must start a transaction before you can
perform a COMMIT or ROLLBACK operation. To start a transaction,
issue a START TRANSACTION operation.
352 Record Count Must Be Greater Than Zero
NetWare SQL received a record count value for the xFetch call that is
not more than zero. The record count for an xFetch call must be at
least 1.
** End of XTROS2.DOC **